Retail Agent Clearing Account Reconciliation Report

The Retail Agent Clearing Account Reconciliation report is used for clearing Retail Agent receivables and payables through accounting transactions such as Retail Agent Reconciliations, Receive Payments and Disbursements.

This report shows the details of the transactions that make up the balance of the retail agent clearing account. Only transactions that do not have an off-setting debit or credit are included, i.e. “outstanding” transactions. Once an off-setting entry has been posted, (given the report is requested with an As Of date to include both the initial transaction and the off-setting transaction) the initial transaction that was once “outstanding” will no longer appear on the report.

To Generate a Retail Agent Clearing Account Reconciliation Report

1. On the Primary menu, click REPORTS.
2. On the REPORTS menu, click Reports. The Nexsure Reports dialog box is displayed.

3. In the Report Type list, select Accounting.
4. In the Report Category list, select Reconciliation.
5. In the Available Reports list, select Retail Agent Clearing Account Reconciliation.
6. Click OK. The summary tab is displayed.

7. On the Navigation Toolbar, click New Report Criteria to go to the Nexsure Reports > Report Criteria dialog box.

8. Under Organization Info, click [Select]. The Nexsure Organization Criteria dialog box is displayed.

9. In the Nexsure Organization Criteria dialog box, select the desired organization information (in the Region and Territory lists) to query for the report and click Add.  

Note: If the report is being run for the entire organization it is not necessary to make a selection in the Nexsure Organization Criteria dialog box. Multiple Regions or Territories may be selected for each report. First select the regions to determine the available territories. All territories for all selected regions will be displayed for selection.

Once information has been added to the Include list, it can be removed by selecting the item and clicking Del to remove individual items or Clear to remove all items.

10. If the organization information is correct, click OK. The organization information selected is added to the Nexsure Reports > Report Criteria screen.
11. In the Date Information area, select the "As Of" date for the report. Set the end date of the report by using either the calendar dialog box or entering a date in the box.

12. In the Group/Sorting Options area, select the grouping and sorting options that affect the layout of the report.

The available options are:

• Group Field [1]: Apply a primary grouping by Territory or select another option. Available selections are Date Booked, Region, Retail Agent,and Transaction Type.
• Sort Field [1]: Sort transactions in ascending or descending order within groups. Available selections are Retail Agent Name, Amount, Date Booked and Transaction Type.
• Sort Order: Select either Ascending or Descending to sort transactions within the group field selected. Ascending will set the order from A-Z. Descending will set the order from Z-A.

13. In the Report Format Options area, select one of the options in the Format Type list.

The available formats are:

1. PDF: This is the default setting that creates the report in a PDF format. The report data is static and cannot be manipulated.
2. XLS: Microsoft® Excel® document that can be manipulated as an .xls file. The report is generated with the same formatting used in the PDF format so cells are merged and data may not be stored in individual cells.
3. XLS (unformatted): Microsoft® Excel® document that can be manipulated as an .xls file. The report is generated with no formatting except for the inclusion of column headers.
14. In the Nexsure Reports > Report Criteria dialog box, click OK. The Retail Agent Clearing Account Reconciliation report will start compiling.

15. To update the compiling status, click Refresh on the Navigation Toolbar.

16. Once the report Status is Complete, click the View icon to view the report. 

Related Topic

Working with Reports